[dbo].[Name_FRSurveyQuestion]

Property	Value
Created	11:09:01 AM Friday, August 06, 2010
Last Modified	11:40:04 AM Monday, February 20, 2012

Property

Value

Created

11:09:01 AM Friday, August 06, 2010

Last Modified

11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$	ID	varchar(10)	10
$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$	SEQN	int	4
	MEETING	varchar(10)	10
	QuestionID	varchar(1000)	1000
	AnswerID	varchar(1000)	1000
	AnswerValue	varchar(6000)	6000

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$

varchar(10)

$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$

SEQN

int

MEETING

varchar(10)

QuestionID

varchar(1000)

1000

AnswerID

varchar(1000)

1000

AnswerValue

varchar(6000)

6000

	Name	Columns	Unique
$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$	PK_Name_FRSurveyQuestion	ID, SEQN

Name

Columns

Unique

$Cluster Primary Key PK_Name_FRSurveyQuestion: ID\SEQN$

PK_Name_FRSurveyQuestion

ID, SEQN

SQL Script

CREATE TABLE [dbo].[Name_FRSurveyQuestion]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SEQN] [int] NOT NULL,
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QuestionID] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AnswerID] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AnswerValue] [varchar] (6000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_FRSurveyQuestion] ADD CONSTRAINT [PK_Name_FRSurveyQuestion] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO